package com.sky.mapper.Common;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface SortUrlMapper {
    @Select("select short_url from tb_short_url_info where trade_no=#{tradeNo}")
    String selectCodeByTrade(Long tradeNo);

    @Delete("delete  from tb_short_url_info where trade_no=#{tradeNo}")
    void deleteCodeByTrade(Long tradeNo);
}
